home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Tech Arsenal 1
/
Tech Arsenal (Arsenal Computer).ISO
/
tek-04
/
ov_all.zip
/
TI636.ASC
< prev
next >
Wrap
Text File
|
1991-09-11
|
3KB
|
133 lines
PRODUCT : ObjectVision NUMBER : 636
VERSION : 1.0
OS : WIN
DATE : September 11, 1991 PAGE : 1/2
TITLE : Creating a second index in Paradox to use in
ObjectVision
Description: This document explains how to create a secondary
index in Paradox and use it in ObjectVision. This is handy when
searching for a "Closest Match" in ObjectVision. The field in
the closest match must be keyed in order for ObjectVision to find
it. If it is not keyed on the primary index in the database, you
need not restructure the entire database. All you have to do is
create a secondary index for the field.
There are two steps in this process. 1.) Write and run a short
script in Paradox to create the secondary index. 2.) Create a
link to this table in ObjectVision, using the desired field as
the secondary index.
Load the file into Paradox and View the table you would like to
create the index on. Move the cursor to the desired field and
press ALT-F10. Select MINISCRIPT from the menu. Type the
following script:
INDEX MAINTAINED TABLE() ON FIELD()
likewise you could also type
INDEX MAINTAINED "TABLENAME" ON "FIELDNAME"
where TABLENAME is the name of the table you wish to run the
secondary index for and FIELDNAME is the field you wish to create
the secondary index on. The quotes ARE needed if you use this
method.
Then press the ENTER key. This will run the brief script,
creating the secondary index. This index information will be
stored in a file in the same directory as the original table.
(It is not necessary to know the filename, but it will have the
same name as the database file, with an extension starting with
X0, or Y0, followed by a number.) Now exit Paradox and start up
ObjectVision.
Paradox now has to be told that it needs to maintain secondary
indexes. Run the CUSTOM script in Paradox. Choose
PAL|MaintainIndexes and select "Yes". Be sure to save this
change when you exit Paradox. This only needs to be done once
for each copy of Paradox that will be accessing files with
multiple indexes.
PRODUCT : ObjectVision NUMBER : 636
VERSION : 1.0
OS : WIN
DATE : September 11, 1991 PAGE : 2/2
TITLE : Creating a second index in Paradox for use by
ObjectVision
Create an ObjectVision form you will link to this database table.
Follow the procedure "Linking to Paradox Files" in the Reference
manual, chapter 10, Linking to Data Files. In the link menu
place the name of the field in the Paradox table you want to use
as the secondary link (don't enter the secondary index file
name).
When you finish creating this link, it will be indexed on the
secondary index field. Searching on this field will now be
possible.